2016-02-28 - 25082 - Spec - Profit center substitute rules #FICOSupport #FISD #PCASub
SPECIFICATIONS
25082-Spec-Profit Center substitution rules
Purpose
Profit Center substitution rules
Admin Info
Purpose
|
Profit Center substitution rules
|
Requested By
|
Baiwa
|
Spec Created By
|
Raghav
|
Spec Created Date
|
02/28/2016
|
Spec QA by
|
Raghav
|
Objects
|
MV45AFZZ
ZSATCODE
ZRETAIL_CUSPC
TDDAT
TVDIR
ZRETAIL_CUSPCS
ZRETAIL_CUSPC
|
Document Status
|
Completed
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
06
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
06
|
4
|
Unit test in DEV
|
10
|
5
|
Unit test in QUA
|
08
|
6
|
Other activity
|
|
|
TOTAL
|
32
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
Documents
[Attach any document(s) received for the requirement(s)]
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Use user exits to change the profit center at sales order
|
Jingsha
|
05/06/2016
|
Approve to use user exit
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
Profit Center substitution rules by sales org and customer ID in sales order and the same profit center should reflect for COGS account at PGI.
Create Z custom table with fields
Sales Org
Customer
Profit Center
In Scope:
[List the
activities to be included in scope]
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Implement substitute for profit center by standard procedure by using the substitute rule in 0KEM and assign it to 0KEL
As in 0KEL we are unable to assign the profit center substitute rule as the system is not accepting multiple substitute rule for same controlling area so that is the reason we are looking for other alternative by using user exit.
Use user exit MV45AFZZ to substitute profit center
Logic: Create Z custom table as below and pull the profit center in sales order if the sales org and customer matches to the custom table.
Sales org
|
Customer
|
Profit Center
|
|
|
|
|
|
|
Test Plan
[List test scenarios/cases to be executed here]
Test ID
|
Test Scenario
|
Expected Results
|
Actual Results
|
FI-001
|
Create the sales order which will substitute the profit center for retail customer maintained in custom table
|
Sales order profit center should be substituted by the profit center maintained in custom table irrespective of inventory profit center
|
Sales order profit center substituted as per the custom table
|
FI-002
|
Create the sales order for retail customer which is not maintained in custom table
|
Sales order profit center should be pick from inventory profit center
|
Sales order profit center is picked as per the inventory
|
Solution Details
- Added logic in userexit MV45AFZZ to read the customer and sales org from table ZRETAIL_CUSPC and update the profit center.
- A table ZRETAIL_CUSPC is created and likewise the profit center is substituted for the respective sales organisation ,customer in the sales order creation.
- A transaction ZRETAIL_CUSPC is assigned for the table maintainance of table ZRETAIL_CUSPC.
Issues
[List Issues / Bugs identified in configuration or development]
Test ID
Test Scenario
Expected Results
Actual Results
P/F
Documents
Notes
Tested By
QA By
FI-001
Create the sales order which will substitute the profit center for retail customer maintained in custom table
Sales order profit center should be substituted by the profit center maintained in custom table irrespective of inventory profit center
Sales order profit center substituted as per the custom table
P
Sales order: 1949281
Inventory PC: PC0060, PC0061
Sales order PC: PC2500 from custom table
N/A
Raghav
Raghav
FI-002
Create the sales order for retail customer which is not maintained in custom table
Sales order profit center should be pick from inventory profit center
Sales order profit center is picked as per the inventory
P
Sales order: 1949281
Inventory PC: PC0060, PC0061
Sales order PC: PC0060, PC0061 from inventory
N/A
Raghav
Raghav